<!DOCTYPE HTML>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>

<body>
<cfset empnum = Trim(form.argid) />

<cfquery name="getBasic" datasource="#client.company_dsn#" maxrows="1">

	SELECT DEPARTMENTCODE, POSITIONCODE, FIRSTNAME, LASTNAME
      FROM #client.MAINTABLE#
     WHERE #client.mainpk# = '#empnum#'

</cfquery>

<cfquery name="getPosition" datasource="#client.company_dsn#" maxrows="1">

	SELECT DESCRIPTION, POSITIONCODE
      FROM CLKPOSITION
     WHERE POSITIONCODE = '#getBasic.POSITIONCODE#'

</cfquery>

<cfquery name="getDepartment" datasource="#client.company_dsn#" maxrows="1">

	SELECT DESCRIPTION, DEPARTMENTCODE
      FROM CLKDEPARTMENT
     WHERE DEPARTMENTCODE = '#getBasic.DEPARTMENTCODE#'

</cfquery>

<cfoutput>~trimstartshere1~#getPosition.DESCRIPTION#~trimendshere1~</cfoutput>

<cfoutput>~trimstartshere2~#getPosition.POSITIONCODE#~trimendshere2~</cfoutput>

<cfoutput>~trimstartshere3~#getDepartment.DESCRIPTION#~trimendshere3~</cfoutput>

<cfoutput>~trimstartshere4~#getDepartment.DEPARTMENTCODE#~trimendshere4~</cfoutput>


</body>
</html>